package hr.mapper;

import hr.entity.DO.EmployeeProbationReviewDO;
import hr.entity.Probationreview;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 试用期审查表 Mapper 接口
 * </p>
 *
 * @author zzh
 * @since 2023-12-10
 */
@Mapper
public interface ProbationreviewMapper extends BaseMapper<Probationreview> {
    //获取所有数据
    List<EmployeeProbationReviewDO> getAll(@Param("name") String name,
                                           @Param("isTurned") Boolean turned,
                                           @Param("isRejected") Boolean rejected,
                                           @Param("isDelayed") Boolean delayed,
                                           @Param("offset") long offset,
                                           @Param("limit") Long limit,@Param("sql") String sql);
//    List<EmployeeProbationReviewDO> getAll(@Param("name") String name,@Param("probationStatus") String probationStatus, @Param("offset") Long offset, @Param("limit") Long limit);

    //删除试用期员工
    int deleteByProbationId(@Param("probationId") Integer probationId);


    List<EmployeeProbationReviewDO> getProbationReviewExcel();

    long getAllCount(@Param("name") String name,@Param("sql") String sql);
}
